package WWW.SST.LIB;

/** 
 Comm ��ժҪ˵����
*/
public class Comm
{

	//public static 
	public Comm()
	{
		//
		// TODO: �ڴ˴���ӹ��캯���߼�
		//
	}


	public static DataTable GetTeuzhuRecord(int uid, String status, String startTime, String EndTime)
	{

//C# TO JAVA CONVERTER TODO TASK: There is no preprocessor in Java:
			///#region
		String sql = " select  top 1000000 *    from   daigou ";
		if (uid == 0)
		{
			sql = sql + " where 1=1 ";
		}
		else
		{
			sql += " where hy_num=" + String.valueOf(uid);
		}

		if (status.equals("") || status.equals("���м�¼"))
		{
			sql += " and 1=1";
		}
		else if (status.equals("׷��"))
		{
			sql += "  and zhuihao='" + status + "' ";
		}
		else if (status.equals("���н�"))
		{
			sql += " and zj_jiangjin>0  ";
		}
		else
		{
			sql += "  and zt='" + status + "' ";
		}



		if (startTime.equals(""))
		{
			sql += " and 1=1";
		}
		else
		{
			sql += "  and addtime >= '" + startTime + " 00:00:00'";
		}

		if (EndTime.equals(""))
		{
			sql += " and 1=1";
		}
		else
		{
			sql += "  and addtime<='" + EndTime + " 23:59:59'";
		}
//C# TO JAVA CONVERTER TODO TASK: There is no preprocessor in Java:
			///#endregion

		sql += " order by  id desc";
		DataTable d = MOLE.SQL.GetDataTable(sql);


		return d;

	}

//		public 
//
//		  string text = "select top 20 hy_name,zj_jiangjin from daigou where zj_jiangjin <>0 order by addtime desc";



}